Tabela LContractServContractServ

Definicja tabeli LContractServContractServ

Name

LContractServContractServ

Code

LContractServContractServ

Comment

 


Lista kolumn tabeli LContractServContractServ

Name

Code

Con_ContractServID

Con_ContractServID

ContractServID

ContractServID

UnitID

UnitID

UnitsCount

UnitsCount

SequenceNo

SequenceNo

IsExcluded

IsExcluded

DateRestriction

DateRestriction

RatioSchema

RatioSchema


Kolumna Con_ContractServID tabeli LContractServContractServ

Definicja kolumny Con_ContractServID tabeli LContractServContractServ

Name

Con_ContractServID

Code

Con_ContractServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractServID tabeli LContractServContractServ

Definicja kolumny ContractServID tabeli LContractServContractServ

Name

ContractServID

Code

ContractServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna UnitID tabeli LContractServContractServ

Definicja kolumny UnitID tabeli LContractServContractServ

Name

UnitID

Code

UnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UnitsCount tabeli LContractServContractServ

Definicja kolumny UnitsCount tabeli LContractServContractServ

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna SequenceNo tabeli LContractServContractServ

Definicja kolumny SequenceNo tabeli LContractServContractServ

Name

SequenceNo

Code

SequenceNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna IsExcluded tabeli LContractServContractServ

Definicja kolumny IsExcluded tabeli LContractServContractServ

Name

IsExcluded

Code

IsExcluded

Data Type

NUMBER(10)

Mandatory

No

Comment

Informacja o blokadzie danego produktu jednostkowego dla produktu kontraktowego w danym miesiacu - zwiazane ze zmianami prawnymi NFZ.


Kolumna DateRestriction tabeli LContractServContractServ

Definicja kolumny DateRestriction tabeli LContractServContractServ

Name

DateRestriction

Code

DateRestriction

Data Type

VARCHAR2(1)

Mandatory

No

Comment

schemat miesiaca dla swiadczenia szczególowego


Kolumna RatioSchema tabeli LContractServContractServ

Definicja kolumny RatioSchema tabeli LContractServContractServ

Name

RatioSchema

Code

RatioSchema

Data Type

VARCHAR2(2)

Mandatory

No

Comment

schemat krotnosci dla swiadczenia szczególowego


Lista kluczy tabeli LContractServContractServ

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LContractServContractServ

Definicja klucza Identifier_1 tabeli LContractServContractServ

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment